Excel Lesson 4

📘 Data Entry Kya Hai?

Excel sheet mein information enter karne ki process ko Data Entry kaha jata hai.

Data Entry mein hum names, numbers, dates, prices, addresses, employee details aur customer information jaise data enter kar sakte hain.

💡 Professional Excel work mein data ko accurate aur properly organized rakhna bahut important hai.

🔤 Text Data Enter Karna

Excel mein kisi cell mein text enter karne ke liye cell select karke simply type karein.

A1 = Name A2 = Rahul A3 = Amit A4 = Priya

Names, cities, departments aur addresses text data ke examples hain.

🔢 Number Data Enter Karna

Excel mein numbers bhi directly cells mein enter kiye ja sakte hain.

A1 = 100 A2 = 250 A3 = 500 A4 = 1000

Numbers ka use salary, quantity, price, marks aur sales amount jaise data ke liye hota hai.

📅 Date Enter Karna

Excel mein dates bhi enter ki ja sakti hain.

A1 = 01/01/2026 A2 = 05/01/2026 A3 = 10/01/2026

Dates ka use sales records, attendance, invoices aur reports mein commonly hota hai.

📊 Data Entry Example

Maan lijiye ek company ke employees ka basic data Excel mein enter karna hai.

Name Age Department Rahul 25 Sales Amit 28 IT Priya 24 HR Neha 27 Marketing

Har piece of information ko correct cell mein enter karna chahiye.

⌨️ Enter Key Ka Use

Excel mein data type karne ke baad Enter press karne se entry confirm hoti hai.

Type Data ↓ Press Enter ↓ Data Saved in Cell

Enter press karne ke baad selection generally next row ki taraf move hoti hai.

➡️ Tab Key Ka Use

Agar aap ek row mein left se right data enter kar rahe hain, to Tab key useful hoti hai.

Name → Tab → Age → Tab → City

Isse next cell par quickly move kiya ja sakta hai.

✏️ Data Edit Karna

Agar kisi cell mein galat information enter ho gayi hai, to us cell ko edit kiya ja sakta hai.

Cell par double-click karein.
Galat information ko change karein.
Enter press karein.

Example

Old: Rahul New: Rohan

🗑️ Data Delete Karna

Kisi cell ka data remove karne ke liye cell select karke Delete key press kar sakte hain.

Select Cell ↓ Press Delete ↓ Data Removed

⭐ Accurate Data Entry

Professional data entry mein accuracy sabse important hai.

Name ki spelling check karein.
Numbers ko carefully enter karein.
Dates ko properly check karein.
Data ko correct column mein enter karein.
Blank cells ko unnecessary information se fill na karein.

💡 Data Entry karte waqt Accuracy + Organization dono important hain.

📝 Lesson Summary

Data Entry ka matlab Excel mein information enter karna hai.
Excel mein text, numbers aur dates enter kiye ja sakte hain.
Enter key se data entry confirm ki ja sakti hai.
Tab key se next cell par move kiya ja sakta hai.
Double-click karke cell ka data edit kiya ja sakta hai.
Delete key se cell ka data remove kiya ja sakta hai.
Professional data work mein accuracy important hai.

💡 Next lesson mein hum seekhenge: Excel Formatting.

Data Entry in Excel